CREATE TABLE [dbo].[Promotions]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PromotionName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartDate] [date] NULL,
[EndDate] [date] NULL,
[HotelID] [int] NULL,
[Description] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FixedPricePerDay] [decimal] (18, 2) NULL,
[FixedPricePerHour] [decimal] (18, 2) NULL,
[RoomCategoryId] [int] NULL,
[DiscountPerHour] [decimal] (18, 2) NULL,
[DiscountPerDay] [decimal] (18, 2) NULL,
[Images] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[Promotions] ADD 
CONSTRAINT [PK_Promotions2] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
